i = 0

output = open("C:/APS/test.sql", 'a')
while i < 10000:
    i += 1
    sql = f"INSERT INTO [dbo].[MY_WH] ([WH],[NAME],[ATTRIB],[DEP],[ADR],[TEL_NO],[FAX_NO],[UP_WH],[CNT_MAN],[INVALID],[STOP_DD],[CODE_NO],[CHK_WH],[REM],[SENDCUS_NAME],[CON_MAN],[USR],[CUS_NO],[ISLC],[SPC_ID],[ISIOWH],[ISYL],[DEPRO_NO],[NAME_PY],[SEND_WAY],[SEND_WH_KD],[COUN_ID],[CW_FLAG],[FLAG_FKC],[WMS_ID],[FLAG_DG],[DG_TYPE]) VALUES ('{i}','{i}','','','','','','','','F',NULL,'','','',NULL,'','KAER','','F','1','','F','','First Stock','','',0,'','','','','');\n"
    output.write(sql)
output.close()
